﻿using System;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using MaLu.Data;
using MaLu.Common;
using MaLu.BusiLogic;
using System.Text;
using MaLu.Framework.Common;

namespace MaluJg.web.PovertyIn
{
    public partial class UVStudy : SUserControl
    {
        
        public void LoadData()
        {           
            
            DataTable dt = SqlHelper.Instance.ExecuteDataTable(Provider, @"SELECT *  FROM [SStudy] where id=" + RecordID);
            if (dt.Rows.Count > 0)
            {
              
                DataRow dr = dt.Rows[0];
                tbYear.Text = dr["Year"].ToString() + (dr["HalfYear"].ToString() == "0" ? "上半年" : "下半年");
                tbName.Text = dr["Name"].ToString();
                tbAdd.Text = dr["address"].ToString();
                tbSchool.Text = dr["School"].ToString();
                tbIDNum.Text = dr["IDNum"].ToString();
                tbMoney.Text = dr["Money"].ToString();

                tbType.Text = dr["household"].ToString();
                tbVillage.Text = dr["belongto"].ToString();
                tbStuName.Text = dr["StudentName"].ToString();
                tbGendar.Text = dr["gender"].ToString();

            }
        }
    }
}